package com.xtkj.stcrm.dao;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.ResultMap;
import org.apache.ibatis.annotations.Select;

import com.xtkj.stcrm.pojo.Employee;


public interface IEmployeeMapper {

	@Select("select a.*,b.dept_name from tbemployee a , tbdept b where a.dept_no = b.dept_no ")
	@ResultMap("BaseEmployeeResultMap")
	List<Employee> listEmps(Map<String, Object> params);
	
	@Delete("delete from tbemployee where emp_no =#{empNo}")
	void delEmp(@Param("empNo") Integer empNo);
}
